package cn.lb.framework.poi.test.entity;

import cn.lb.framework.poi.excel.annotation.Excel;
import cn.lb.framework.poi.excel.annotation.ExcelEntity;
import cn.lb.framework.poi.excel.annotation.ExcelTarget;
import cn.lb.framework.poi.excel.annotation.ExcelVerify;

import java.util.Date;

/**
 * Created by Administrator on 2016/4/25.
 */
@ExcelTarget("student")
public class StudentEntity implements java.io.Serializable {

    private String sid;
    @Excel(name = "姓名",width = 75)
    private String name;
    @Excel(name = "生日",format = "yyyy-MM-dd HH:mm:ss",width = 25)
    private Date birthday;
    @Excel(name = "年龄")
    @ExcelVerify(notNull= true,interHandler = true)
    private Integer age;
    @Excel(name = "性别",replace = {"男_0","女_1"})
    @ExcelVerify(notNull = true,interHandler = true)
    private Integer sex;
    @Excel(name = "手机号")
    @ExcelVerify(notNull = true)
    private String phone;
    @Excel(name = "邮箱")
    @ExcelVerify(isEmail = true, notNull = true)
    private String email;
    @Excel(name = "薪水",isStatistics = true)
    @ExcelVerify(notNull = true)
    private String salay;
    @Excel(name = "备注")
    private Double remark;
    @ExcelEntity(id = "teacherEntity")
    private Teacher teacher;
    @ExcelEntity(id="courseEntity")
    private Course course;

    public String getSid() {
        return sid;
    }

    public void setSid(String sid) {
        this.sid = sid;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public Integer getSex() {
        return sex;
    }

    public void setSex(Integer sex) {
        this.sex = sex;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getSalay() {
        return salay;
    }

    public void setSalay(String salay) {
        this.salay = salay;
    }

    public Double getRemark() {
        return remark;
    }

    public void setRemark(Double remark) {
        this.remark = remark;
    }

    public Teacher getTeacher() {
        return teacher;
    }

    public void setTeacher(Teacher teacher) {
        this.teacher = teacher;
    }

    public Course getCourse() {
        return course;
    }

    public void setCourse(Course course) {
        this.course = course;
    }
}
